﻿using System.Data;
using System.Data.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;

namespace AD.EngenhariaTransito
{
    public class Postos
    {

        public static DataSet PesquisarPostosPoliciais()
        {
            Database myDatabase = DatabaseFactory.CreateDatabase();
            DbCommand myCommand = myDatabase.GetSqlStringCommand("SELECT IdEstacao, Descricao FROM dbo.EstacaoAgencia ORDER BY Descricao " );

            DataSet ds = myDatabase.ExecuteDataSet(myCommand);
            return ds;
        }

    }
}
